TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
djelloul reguieg
NA
60
0
JOINT Three tables with sql query
Jun 13 2009 11:04 AM
hello;
I am developping an application with five tables:
the first, second, third and forth table contain one row,
the fifth table contain 12 row;
I would like to retreive this data in one row,
I tried this query but it gives me twelve (12) line
"SELECT DISTINCT table1.*, table2.*, table3.*, tale4.*, table5.* FROM " + "(((table1 LEFT JOIN tabl5 ON table1.Ref1 = table5.Ref1) INNER JOIN table2 ON table1.RefFT = table2.Ref1) " +
"LEFT JOIN table3 ON table1.Ref1 = table3.Ref1) LEFT JOIN (PIECES.*, " + "ON table3.Id_table3 = table4.Id_table3) WHERE (((table1.text1)=" + "32" + "))";
please help me
best rEGARD
Reply
Answers (
1
)
Chart in asp.net
Xml Serialization