If you used join query on parent table and child table and you want to fetch unique records from both table then see the below example
SELECT COUNT(DISTINCT(t1.id)) FROM table1 t1 left join table2 t2 on t2.id=t1.t2id
Enjoy!
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...
ReplyDeleteI have read your blog its very attractive and impressive. I like it your blog.
PHP 7 Training in chennai | PHP 7 Training Course
PHP 7 Training in chennai | Online PHP 7 Course