Posts Tagged ‘two tables’

mysql queries 1. Add column age and desg in emp_prof table. Mysql> use profile; Mysql>alter table emp_prof add column age int; Mysql> alter table emp_prof add column desg char(10); 2. Update all records of emp_prof.(desg= actn,officer) Mysql> use profile; Mysql>update emp_prof set age=24,desg=’officer’ where emp_id=101; Mysql>update emp_prof set age=21,desg=’actn’ where emp_id=102; (follow above queries for […]

inner join on more then two tables in php

Posted: 8th February 2012 by urfusion in php, Uncategorized
Tags: , , , ,

inner join on more then two tables in php select k2.id, k2.title, k2.extra_fields from jos_k2_items as k2 INNER JOIN jos_vm_order_item as oitem ON oitem.order_item_name=k2.title INNER JOIN jos_vm_orders as orders ON orders.order_id=oitem.order_item_id where orders.user_id=62