Help for sql query(joins)
-
hi all, this is my query. I have 3tables(a,b,c). i am connecting table a with table b using columns pinnumber(in a table) with Usernumber(in table b). if this query is correct then only i have to compare third table column (menuid)with second table column(accessid) pls help me out of this problem. Regards sharmi rs_net
-
hi all, this is my query. I have 3tables(a,b,c). i am connecting table a with table b using columns pinnumber(in a table) with Usernumber(in table b). if this query is correct then only i have to compare third table column (menuid)with second table column(accessid) pls help me out of this problem. Regards sharmi rs_net
Your description isn't very easy to understand. What are the primary keys of each table? What are their foreign key counterparts in other tables? ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell