Hi, I have 3 tables involed in my query.
Table1 Table2 Table 3
fk_1 m ---------- 1 pk_2 pk_3
field m --------- 1 field
filed is niether the foriegn key nor the primary key but each one is distinct
I want information from all three tables but I cannot seem to get all of it. One way I get the info from the first 2 tables then another way I try the query I get only info from the third table. If anyone could help, it would be greatly appreciated. Sorry about the explaination if it seems unclear
Table1 Table2 Table 3
fk_1 m ---------- 1 pk_2 pk_3
field m --------- 1 field
filed is niether the foriegn key nor the primary key but each one is distinct
I want information from all three tables but I cannot seem to get all of it. One way I get the info from the first 2 tables then another way I try the query I get only info from the third table. If anyone could help, it would be greatly appreciated. Sorry about the explaination if it seems unclear