Tag Info

New answers tagged

0

Solved: SELECT `conv`.`subject`, `mc`.`message_text`, `mc`.`sentDateTime`, `mc`.id AS "msgId", `conv`.id AS "convId" FROM (`crm_receivers_of_messages` rm) JOIN `crm_messages_of_conversions` mc ON `mc`.`id` = `rm`.`m_id` JOIN `crm_conversions` conv ON `conv`.`id` = `mc`.`conv_id` WHERE `rm`.`receiver_id` = '1' AND mc.id = (SELECT MAX(id) FROM ...


0

The tables can be queried in a few different ways depending on what you want to do. If you wish to (Example 2) extract all the Reviews with a particular Category you can create a procedure like this: SELECT review_id, professional_rating, efficiency_rating, referral_rating... FROM Review r INNER JOIN Review_Category rc ON r.review_id = rc.review_id INNER ...


1

Do not store dates in a separate table unless there is something about a particular date that has additional information that you need to store. In general the date is a simple attribute of some other entity, it isn't an entity in itself unless you have a very peculiar application. One exception to this might be a star schema data warehouse where there ...



Top 50 recent answers are included