MySQL select Query to inner joint two tables on single field.
SELECT CASE
WHEN STATUS_FLAG=1 THEN (select id from table2 where
id=TABLE1.F_ID)
ELSE (select id from table3 where id=TABLE1.F_ID)
END
FROM TABLE1
Subscribe to:
Post Comments (Atom)
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
In today's world of web development, working with images is an essential aspect of building a dynamic and visually appealing website. Ho...
-
- There are so many plugins available for build page on WordPress! 1. Elementor: (Free and Paid both plugin available) - Pricing ...
Good Job. Helpful for beginner and intermediate.
ReplyDeleteThank you sir :)
Delete