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) { ...
-
- There are so many plugins available for build page on WordPress! 1. Elementor: (Free and Paid both plugin available) - Pricing ... -
What is Google reCAPTCHA v3? Google reCAPTCHA is a free service that helps protect websites from spam and abuse. reCAPTCHA v3 is the lates...
Good Job. Helpful for beginner and intermediate.
ReplyDeleteThank you sir :)
Delete