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++ - Cmake produces file extensions in static library archives -

-
I have recently switched to autotools to cement, since the limiter cross platform is better for development and what I saw When I build a stable library of my C ++ code, all the files inside .cpp.o is a suffix ar income tax PA8 / libgenericTZR.a genericTZR.cpp.o I have seen other libraries made by other tools and they do not do it, I'm not sure this is the realm And there is a bad thing, but how can I create static libraries without cpp file extension? This is my CMake file add_executable (PA8 ISP_Charges.cpp genericTZR.cpp genericTZR.h) set (LIBSRC genericTZR.c genericTZR.h) add_library (genericTZR shared $ {LIBSRC}) add_library (genericTZR shared $$ TARGET_OBJECTS: myObjects & gt;) install add_library (Generic TZR-static static $ {LIBSRC}) set_target_properties (Generic TZR-Static Properties OUTPUT_NAME $ install (TARGETS PA8 DESTINATION BIN) TARGETS GENICTZR GENERICTZR-STATIC DESTINATION lib) Installed (files "$ {PROJECT_BINARY_DIR} /PA8/genericTZR.h...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

c# - XML - Serialize class - Some questions -

-
I have the idea of ​​serializing the properties of a class in an XML-file and then uploading this file to the server The reason for this is that I want to download this file again and read the serialized content. Then this kind of structure: file exists (myfile.xml) - & gt; Serialize the file in data from class (myclass.cs) - & gt; Upload file. Now the content may look something like this: Now the problem is, I do not know how to walk. I want the new data to be serialed in the next way, but it should be linked to that XML-file, not a new one. So I download this file and then I serialize the new data as an attachment so that it will look like this: And it should be repeated many times as I want: download file, serial new data and attach it together, then upload it again. Now, the second issue is, I want to read it. I also use XML-class for this. For the type of ultimate type, the data should be serialized, I set the square in which the assets are. But now,...
Read more