frezno — 2010-11-19T06:13:19-05:00 — #1
I don't get a query over multiple tables to work.
it's driving me nuts... :headbang:
Since i think it's too much to post the (relevant) table structures + test data here, is there any way to provide you guys with that data or shall i post it here nontheless?
guido2004 — 2010-11-19T06:47:08-05:00 — #2
You could start by posting your query, and explain what you want to achieve.
Then, if necessary, you can post the table definitions and test data.
r937 — 2010-11-19T08:01:20-05:00 — #3
just post the query and the error message
frezno — 2010-11-19T08:11:57-05:00 — #4
ok, problem solved
when writing down everything here and going through the data again trying to make it understandable, i realized that there was a missing entry in my table.
Well, as good ol' Konfuzius already said: If data missing you cannot see.
heck, what a shame
ie, my query does work if correct/all data is provided
and now, frez, :x
guido2004 — 2010-11-19T08:21:42-05:00 — #5
Damn, we're good! :lol: