Joined: 06 Jun 2010
Online Status: Offline
Posts: 2
Topic: Joining Commands Posted: 06 Jun 2010 at 5:27pm
I have three tables that are linked together. In one table I have only one column called "PARTS" and in the other two I have three columns "PARTS" "TYPE" and "QUANTITY". I want every record in the first table to show up, but when I add the "QUANTITY" columns to the report, they get filtered out if there is no record of that "PART" in the other two tables.
Is there a way to have all of the records of the first table to show up even if there is no record of it in the other two tables? The two 3-column tables are connected only to the 1-column table by "PARTS". I was pretty much looking to do a right outer join of the two tables to the first one. Is that possible to do? I can't really do it in the SQL because it will get very messy very quickly. I tried doing a subreport and linking by "PARTS" but the report became very slow.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 07 Jun 2010 at 3:23am
go to the screen where you can see how the tables are linked (Database Expert) right click on the link and then you can change the join condition to an outer join.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
