Hey there =)
i have 2 tables with a relationship between them. a Primary key in the one table, and a secondary key referencing the primary key, in the second table.
Now usually when i want to display data in my db i INNERJOIN the two tables, so i can have the primary key and secondary key in one table to then use it to select certain fields... Buttt, i have a feeling that this isn't the correct way to do it.
And i have no idea how to write the query to select all fields in Table 2 where the secondary key is Equal to the Primary key. (without innerjoining them)
Do apreciate your help to improve my code.
Thank you =)
Ruan