newbie: select from a table, conditioned on the entry in another table

Hi I have 2 tables, say A and B. One field in table A, say A_link, points to a field B_link in table B. I need to select entries in A, which fulfill two conditions: A_cond1 = XX and B_cond2 = YY. E.g tabel A table B A_cond1 A_link B_link B_cond2 1

Re: newbie: how to sort a database without extracting the data

3 ie 02 what do you mean by adding an index thanks for your help cheers christoph Damian McMenamin wrote: add an index on the field. would be quickerthan any exporting importing. --- Christoph Lehmann <[EMAIL PROTECTED]> wrote: Hi I am really new to mysql. I need my database to be sorted a

newbie: how to sort a database without extracting the data

Hi I am really new to mysql. I need my database to be sorted according to one field. But since the database with 1200 records is huge, I don't want to do it using SELECT. What I need is just the stored database being sorted on hard-disk. Is there any way doing this like creating a new databa

newbie: delete row xy

Hi I now how to use delete together with a WHERE statement. But e.g. after some warnings revealed me certain rows being inconsisent, and I want to delete them- how can I do this? I just know that I want to delete e.g row 1433 (I have no special id) thanks for a hint cheers christoph -- MySQL Ge