Click here to Skip to main content
15,790,723 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
There is no same attribute in both table User_login or Product So what I do for Select query?
Wayne Gaylard 14-Nov-11 8:00am    
Why do you want to join them?
Mehdi Gholam 14-Nov-11 9:15am    
You have to have something similar in both tables to connect the two with User_Login and Products are fundamentally different and require a intermediary table for the connection.

if they don't have any relation then why you want to join them.
And if they have relation then Why you did't take while creating your data strcture.
Share this answer
Pandya Anil 14-Nov-11 8:10am    
if this is not an answer, I think you should have added it in comment .. :)
1) you can write two different queries inside a procedure.. and get multiple result sets in single procedure call..

2) if data types are same create union all

3) if possible create join both the tables and get your answer filtered by propper conditions.

smile :) :) :)
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900