get n:m relation data with join

[aklebow]

hello all,

i want to get the complete data between two (three) tables. but I get a flawed statement. I do not know where the problem lies.

Database structure:

TBL_User col_ID (PK) | col_username | col_pwd | col_created_at | .....

TBL_Domain col_ID (PK) | col_name | col_created_at | .....

TBL_user_X_domain col_ID (PK) | col_user_ID (FK) | col_domain_ID (FK) | .....

anyone can give me an example query?

[cbornhoft]

I don't think anyone has been able to answer your question, as what you're asking is vague. If you're still having this issue, please add the query you've tried, and exactly what you mean by "complete data between two (three) tables" and "I get a flawed statement". Thanks!