Help with Complex MySql Query Need nested query

blanius

I'm working in MySql 3.23.49 and since there are no nested queries how can I build this query

I need to lookup data in two sub tables to fill in data inplace of id numbers stored in the main table. Where table1_id=table2_id and table1_date=date but I also need for example customer_last from table2 where the customer_id=table1.Customer_id and so on for three tables

My head hurts.

This is a scheduling system where the main table of appointments has app_id cust_id service_id associate_id and I want basically to fill these id's in with real data where the app_date=givendate

Hope I made sense there.

Thanks

stolzyboy

just do one query to get whatever you need to put in the second query, for example if you wanted to do this

select * from table1 where id = '(select memberid from table2 where id = '4')'

you could do

query 1
select memberid from table2 where id = '4' // set that equal to a variable, then do second query

query 2

select * from table1 where id = '$variableyousetqueryonequalto'

something like that should help you out

blanius

thats what I started to do but I'm trying to display all appointments for a week so I end up with too many queries. like 4 for each weekday. The other thing I was trying was to load * from my sub tables and use PHP to search through them with info from my main Query

Just seems I could build a complex query for this but perhaps not.

stolzyboy

you may be able to do some joins, other than that i don't know

ultraslacker

You may be able to do this by OUTER JOINs and aliasing multiple instances of the tables. Your explanation lacked useful information, such as a schema and actual sql.

eoghain

Your data can be retrieved using some simple joins. Post your schemas and some sample data and a sample of what data you want back and we will be able to show you a query that works.

blanius

Man o Man. I thought I was going crazy. I thought perhaps I just didn't know how to do a join, but it turns out the problem was that my partner had entered bogus data in the database while checking some of the other admin pages and that was giving me bad queries. In otherwords it was fine the way I was doing it.

Thanks for the feedback guys

stolzyboy

lol, just an idea, you could break your partners fingers, then he/she couldn't type any bogus data, j/k, glad you got it figured out