Search results

no success...... ;-(

Bad news now..... Tested in Access works - but it doesn't for mySQL ;-( that is what I need it for... Just using Access to test queries. hmm.... doesn't like "first" I think...

Nice, You are a star! Thank you.

I can't really follow that.... Is it something like that: SELECT tableA.fieldA, tableA.fieldB, tableB.fieldA FROM tableA LEFT JOIN tableB ON tableA.fieldID = tableB.fieldID GROUPE BY tableB.fieldID; ???

HI all, I have a simple query: SELECT tableA.fieldA, tableA.fieldB, tableB.fieldA FROM tableA LEFT JOIN tableB ON tableA.fieldID = tableB.fieldID; So now if there are two entries in tableB for any entry in tableA I will have two results for that field, but I just want to have one (the first...

Yep, you are right... I just wasn't sure at that time what you meant by that.... But thaks for helpping me and for all your time. stone28

Damn, don't even tell me about it ;-).... So Simple! I wasn't using Access and SQL for way too long...... Now I can move forard with it. Slowely but surely... Thank again. stone28

GOT IT!!!!!!!! Thank you very much .......... Outer Join is the winner..... So simple... o my god!!!!! Thanks.... SELECT tbl_movies.movie_title, tbl_movies.movie_title_org, tbl_movies.movie_year, tbl_movies.movie_imdb, tbl_movieGenreCompact.genre_id FROM tbl_movies LEFT OUTER JOIN...

I think that is what I need but I have problem with creating one.... That's why I am here.... Looks like I'm not really good at it, because I really think it's preatty simple query, and still too dificoult for me at this point ;-( SELECT tbl_movies.movie_title, tbl_movies.movie_title_org...

Thank you, thank you and once again thank you guys..... for all the suggestions. As for my query in the post #6 that is exactly wha tI wanted but as I wrote in the post #6 at the bottom, it lists only movies with genre attached to them. So if I have 10 movies in my main movie table but only 4...

OK, I can see what the problem is and why you can't understand what I am trying to say - that it's not an ID field.........On my relations screen there shouldn't be connection between tbl_movieGenreCompact and tbl_movieGenre... - that's why I am saying that it's just a string. Sorry again. So...

But I just want you to treat the content of tbl_movieGenreCompact.genre_id as normal String..... There are no ID as far as the SQL is concern..... it's just a string - 10,2 or 1,3 or blablabla..... It doesn't matter..... it's just a string for me no values normal simple string.....

Please ;-) I just want to know that SQL query!!!! I will might change the DB but it's really small app for me and my friends so in this case I want to make it as simple as possible for me to move forward and the way with comma looks to me OK (I was using something similar before and it worked...

But in my case my way would work better for me, as I will be doing a lot of processing on the ASP page side, and it will make it easier for making AJAX calls to the DB.... Please can somebody tell me how to create that SQL call. That's is all I need. I might decide to make it your way but first...

hi again, I just want to create query which will give me that in the result: all movies, and genre_id field (not access ID field - just content of that field - it's not autonumber - it's just text field which I will be filling with outside code) next to the ones which have something there...

Sorry for not being more detailed. So it looks like that: I was thinking, should I have one entry for each movie category, so instead of two here (2 movies, 2 categories each but after comma) would be 4 records (2 movies 2 categories each). I decided for the first option (on the picture)...

hi again, as I wrote in my first post: the tbl_movieGenreCompact is the table that conects tbl_movies and tbl_genre. It keeps the movie_id and genre_id that movie belonges to. That;s the beginning of it: And what tbl_movieGenreCompact holds: So it's displaying only movies which have...

Thanks, shame it has nothing to do with my question. IMDB is not really the place where I can leave some comments about the movie for my friends and vice versa.

Hi All, I am trying do create simple online movie DB for myself and my friends to use, but first of course I have to design properly my DB. As I am not really good with SQL I have problems straight at the beginning ;-(. The error I am having is: "The SWL statement could not be executed...