mysql - Getting rows of a table based on query on another table -

-

I have these 2 tables 

  [product] id company id, name, part No, IDS Group, for the company name to search the user, when searching for a company name, I have to show this column:  
  company name, product. Name, Product. Part, Product IDS Group  
 
 Find me the company ID from this search query 
 
  Choose company.ID from the company where "$ userSearch%" such as WHERE Company.Name < / Code> 
 
 Now I want to use Company.ID for this query to get all the products from the product. 
 
  Select * Product from WHERE Company ID = "ID from previous query"

If it's in the same database, then you just have to Join Tables

< Code> Select Company. Name, Product. Name, Product. Partano, Products Company on products leaving company from IDS Group Id = products. Companad is where the company Name LIK e "$ userSearch%"

Comments

Post a Comment

Popular posts from this blog

c# - The item with identity 'Id' already exists in the metadata collection. Parameter name: item -

-
मेरी सभी संस्थाओं का आधार वर्ग है: सार्वजनिक वर्ग इकाई & lt; TKey & gt; : आईएरिटीटी & lt; टीके & gt; {गतिशील आईईआरटीईटी.आईडी {प्राप्त करें} इस आईआईडी; } सेट {this.Id = मान; }} सार्वजनिक TKey Id {get; सेट; }} उदाहरण के लिए स्थिति इकाई: [मेटाडाटा टाइप (टाइपफ (स्टेटसमैटडेटा))] सार्वजनिक आंशिक श्रेणी की स्थिति: इकाई & lt; बाइट & gt; {सार्वजनिक स्ट्रिंग शीर्षक {प्राप्त करें; सेट; }} जब मैं डेटाबेस के विरुद्ध क्वेरी चलाऊँगा तो मुझे निम्न त्रुटि मिलती है: "पहचान 'आईडी वाला आइटम पहले से ही मेटाडेटा संग्रह में मौजूद है। पैरामीटर का नाम: आइटम" क्या यह तय करने का कोई तरीका है या यह किसी वारसा के कारण हुई समस्या है और मैं किसी भी वर्ग से अपनी संस्थाओं का वारिस नहीं कर सकता हूं? यह एक सामान्य त्रुटि है, कुछ जानकारी के लिए खोज करते हुए, मैंने देखा कि: दो तालिकाओं को एक प्राथमिक कुंजी के लिए एक ही नाम हो सकता है लाइटस्विच टेबल्स को देखो, उन सभी को एक प्राथमिक कुंजी है जिन्हें आईडी कहा जाता है। इसलिए, मैं सभी संस्थाओं की समीक्षा करता ह...
Read more

jquery - How to make a wrapper function in javascript? -

-
I have a very low click handler: $ (document) .on (' Click ',' .xxxbtn ', function (e) {....}) I want to save one of the cookies in some of them. I can write down like this: function default handler (e, callback) {callback (e); DoSomeJobs (); } $ (Document) .on ('click', '.xxxbtn', defaultHandler (e, function (e) {`different code in each BTN .... ....}) But I think it should be handled well ( just look better and clear ): $ (document) .on ( 'Click', ' update m Maybe my example is a bit unclear. I mean if i can create defaultHandler as function statement in javascript? Just function short answser : No, there is no way to say defaultHandler (e) {...} Long answer : It is possible to achieve something like this: order functions, functions which return the function ns. Yes In JS, such a thing is possible, and even clean, short codes are required to be written. First of all, start with a simple ex...
Read more

sql - PostgreSQL automatically update row at specific date -

-
Once I update one line, I want to reach the specific timestamp in that line. For example, there are deals in an auction site which ends in one day. After that time the deal ends automatically. Is there a feature in PostGrace SQL, where I can set a line to automatically update when it reaches a specific time period? Otherwise how do I apply this example bargain feature? One view can work for it Suppose a table T Create table T (deal_ID integer, deal_time timestamp, end time interval); Enter T (deal_id, deal_start, expiry_time) values ​​(1, now (), '1 day'); If this deal is over, then a view will be Caletrack Select View vs. *, now ()> At the end of T, deal_start + expiry_time; Choose from V * Deal_id Deal_start | Expiry_time | Ended --------- + ---------------------------- + -------- - --- + --------- 1 | 2014-04-22 13: 26: 32.319394 | 1 day | F
Read more