Problem in writing query

[Arushee Jha]

Hi,

I am a beginner in mysql and need your assistnce.
I have three tables A, pk a, B pk b fk a,C pk n fk a. where pk is primary key and fk is foreign key and many other fields in all three tables.

I want to write a query to read everything from three tables.
and for the I wrote query like

select * from A a, B,b, C c
where A.a = B,a
and A.a= C.a

I am getting the result as cartisan product. Could u please let me know the better approach.

Thanks in advance.