Hi All,

I need your help.

How can i find the joins between two tables using sybase system tables.

For Example :
I have Table A ( a_name , a_id , a_last )
Table B ( a_dep , a_depid , a_id )

Now i want to write the query that will find the Join between Table A and B

i.e. a.a_id = b.a_id ( i want to get this using query )


Please let me know how can i write the query to achieve the above.


Thanks you all in Advance!!!!

Thanks,
Hemant