Member Avatar for aerliana 
"SELECT tbl1.staff_ic, tbl1.staff_name, tbl2.dec_status,tbl4.location,
					tbl3.post,tbl3.grade			
					FROM staff_detail tbl1
					INNER JOIN staff_declare tbl2
					ON tbl1.staff_ic = tbl2.staff_ic
					INNER JOIN staff_post tbl3
					ON tbl1.staff_post = tbl3.num
					INNER JOIN staff_department tbl4
					ON tbl1.staff_dep = tbl4.no
					";

isn`t my coding is right?? why when i execute my command just certain data are appear and the rest not appear

Edited by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by network18
Member Avatar for network18

explain what result you want to achieve through this, and why so many tables for storing just simple data.post your table structures also

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.