PDA

View Full Version : Table in My SQL


cheaphotel
11-10-2007, 03:03 PM
Dear friends ,

i have three table which name name quest (count int , ques varchar(30)) ,checkans(ccount int ,ans int ),showans(qno int ,ans varchar(25))

i want to join all three table via count && qno and ccount so that i can get
unique vale of question , ans int , ans varchar

How can it possible?

guelphdad
11-10-2007, 04:12 PM
note that COUNT is a reserved word so you should change that name in your first table.

as for your joins, show us what you have tried and we can help you troubleshoot to get a final answer if you can't get it working.