Im need a piece of code that will allow me to solve the following problem, not quite sure what funtions to use.
I have to tables in MySQL with different data except for one field 'ID' acts as a primary key
I need to create a new table that has records in as a result of querying a third table with user details using filtering criteria stored in one of the first two tables (above)
Then in each of those new records i also need a field from the other of the first two tables
If anyone can get their head around this i would greatly apperciate any feedback
thanx Rob
