in reply to Re: Module Design Review -- DB mini language
in thread Module Design Review -- DB mini language
And if you are joining two tables on a column that has the same name in both tables you can:SELECT words.id, words.definition FROM stock JOIN languages ON (stock.languageID = languages.id) JOIN stockmatch ON (stockmatch.stockID = stocks.id) JOIN words ON (stockmatch.wordID = words.word_id) JOIN types ON (words.typeID = types.id) WHERE stock.word = :stock_word AND language.name = :language_name AND type.name = :type_name
SELECT * FROM table_one JOIN table_two USING (join_column)
|
|---|