Join the tables with common columns with those do not have . E.g. t1 and t2 do not have common columns but t3 and t4 have common columns eachother and with the t1 and t2 . Then just join with t3 with t1 and t4 with t2 and then t3 and t4 , but select the columns from t1 and t2. I hope this might help if i have correctly understood your question. Thanks
How to join the data of two tables which does not have common columns but can be done by using two others tables but How?
I have four tables and wants to extract data only from two tables but they do not have any common column so i have to use other two also because three tables are having the common columns.
Can you please provide the technical details of this its very urgent Please...
Now you have 4 tables T1, T2, T3, T4. You want to extract data from T2 and T3 which do not have a common column. But say both T2 and T3 have common columns with T1 and T4. In this case you need to use the common columns only in the join condition, but you are not retrieving any data from T1 and T4.
Tell me if this resolves ur issue or that if you need further assistance.
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.