Originally Posted by rawkas
hi guys, any chance with help on the following question? would be much appreciated!
MySQL is a relational database management system. The data is structured as a set of tables linked by relations. Assume the following database has been setup for you.
3.3.1 Write the SQL to list postcodes and names of people who live there.
3.3.2 Write the SQL to list postcodes and people who live there (where applicable) for all properties regardless of whether the property is inhabited.
3.3.3 Write the SQL to list people and postcodes (where applicable) for all people regardless of whether they live in a property that exists.
3.3.4 Given values for postCode, firstName, lastName write the SQL statements to create suitable entries for each table. HINT you may need to use Last_INSERT_ID() - assume propId and perId columns have been defined as AUTO_INCREMENT.
This hasn't a thing to do with PHP. Moving to MySQL forum. In the future please choose a better title for your threads.
This is clearly homework. Please post your current SQL attempts and the problem you are currently seeing with it.