- select * from books where id not in (select id from issued_books)
I am new to this community also....
Lets see-- I dont know - how you are doing this. wt kind of software you are using.
Because i am using ASP.net Visual web developer and MYSQL - here i am using navicat to access MYSQL database.
Wt you do - go to MYSQL through Navicat and make tables you need.
Then go to Visual web developer and just add SQL DATA SOURCE choose those tables and columns you want to show on web and Select SQL data source 1and go to properties and go to select query -- after that new window will appear and go to query builder and right click add table. Now here it will show you one table already and then just add the another table you want the relation ship with --- choose appropriate columns and click ok.
AND YOU ARE DONE--- THATS IT.
Output: Whatever columns you have chosen will appear on you page. Its called retriving data from two or more tables on same page.
I hope that would help.........
I have question for you ':::::::::::::::::::::::::::::::::::::::::::::
Hi I am new at ASP and MYSQL.
I am Using Navicat to access MYSQL database.
My Problem is when i create the foreign key -it gives me this error.
1452-cannot add or update child row: a foreign key constraint fails....
Can any body help me - why am i getting this error - and how to fix it --
Thanks,
Harsh