I need to perform a join on six different tables to produce a report. The biggest join I have ever done has been four tables. The way I did that query was to join three tables and then to perform the final select on the three table join.
Can anyone give me some advice. Should I use the same approach? Or can I just continue to use the keyword INNER JOIN to perform the joins?
If you need the 6 tables to get the data you want then you have to use the tables. Whether you need to use INNER JOIN or other joins depends on the data. There's nothing wrong in joining 6 tables in one query.
No comments:
Post a Comment