database - How to display data from multiple tables in SQL -


i'm relatively new sql. i'm trying figure out how satisfy condition: display customer_id, customer_last_name, order_id,order_item_id, product_name customer living in virginia.

so far, have this, i'm not sure how display values together. appreciated. 

select customer_id, cust_first_name demo_customers cust_state= 'va'  select order_id demo_orders customer_id= '1'

you need join

select customer_id, cust_first_name, order_id, order_item_id, product_name demo_customers inner join demo_orders on demo_orders.customer_id = demo_customers.customer_id cust_state= 'va'

Comments

Post a Comment

Popular posts from this blog

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

Reversible shuffling a int array in java -

this question has answer here: reversible shuffle algorithm using key 4 answers i have int array of considerably large size. need shuffle array using key. should able obtain original array using same key. searched shuffle algorithms 1 found fisher yates not use key. the int array pixel values of image. need hide data it. hiding data after shuffling array enables accessing of data if 1 have key. fisher-yates uses pseudo-random number generator, can seed using key (look cryptographic prngs). reverse process, shuffle array of indices [0, n ) using same key, perform reverse shuffle.
Read more