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)
-
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 ...
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