getting values by joining with different id
Posted: Thu Aug 02, 2007 2:26 am
Hello,
I have two tables,
Table 1: ID, gender, name
Table 2: FILE_ID mem_Id, file_name
ID and FILE_ID (auto inc, pk)
mem_id(fk)
whenever member uploads files, a new row is inserted into Table 2
I want to get all the filenames of members whose gender does not match with the Table 2 mem_id's gender. i.e if male logs in a female files should show.
Thanks
I have two tables,
Table 1: ID, gender, name
Table 2: FILE_ID mem_Id, file_name
ID and FILE_ID (auto inc, pk)
mem_id(fk)
whenever member uploads files, a new row is inserted into Table 2
I want to get all the filenames of members whose gender does not match with the Table 2 mem_id's gender. i.e if male logs in a female files should show.
Thanks