MySQL

My data not appear

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2009

Posts: 7

Reputation: aerliana is an unknown quantity at this point

Solved Threads: 0

aerliana

Offline

Newbie Poster

My data not appear

Oct 22nd, 2009

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
"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
					";
"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

Last edited by peter_budo; 33 Days Ago at 4:56 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)