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)
The Future of Technology: Emerging Trends to Watch in 2025
Introduction As we navigate through 2025, the technological landscape continues to evolve at an unprecedented pace. Innovations that once se...
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
$no = 5; $no2 = 10; $no3 = 6; $maxVal = max($no,$no2,$no3); echo $maxVal; Result: 10
-
If you want to change page title from admin side then please follow below steps: * Login in admin and open CMS > Static pages, th...
Good Job. Helpful for beginner and intermediate.
ReplyDeleteThank you sir :)
Delete