php - SQL select items from one table with conditions from another -

-

i have 2 tables:

accounts(id, name, adress, type)  holidays(name, startdate, enddate)

and type column accounts set("manager","director","administrator") example.

the name column both colums relationed. when creates holiday, name table holidays name account logged in.

and want know if it's possible make sql statement can take of table 2 the table1.type need "director" , table1.name needs on holidays.

select * accounts a, holidays h a.name = h.name , a.type = 'director'

this should entries want. it's important link a.name h.name ensure right combination.


Comments

Post a Comment

Popular posts from this blog

javascript - Why Selenium can't find an element that is graphically visible -

-
i'm using selenium test appllication running on firefox browser, when want click on button selenium, don't find it. find strange since can see element eye. have tried multiple method worked other exemple : wait.until(expectedconditions.visibilityofelementlocated(by)) wait.until(expectedconditions.presenceofelementlocated(by)); (i use xpath in path variable, , i'm sure correct) setting implictlywait on driver putting thread.sleep(1000) then again, post here because don't understand why selenium not see element diplayed on browser. important information maybe giving me proper answer html dom dynamically generate websocket triggered javascript event. edit 1: <button type="button" class="btn btn-xs btn-block btn-stroke" id="252_button"> delete </button> the element i'm trying access. use xpath it. it's not in iframe element. to access element did method supposed find , click on giving xpath in para...
Read more

java - How to compare two classes -

-
i try create factory, here's code: public class myfactory { public static <t> mybase create(class<t> _c) { if (_c.getclass().equals(derived1.class)) // (1) return createnewderived1(); return null; } } // caller myfactory.create(derived1.class); it compiles warning @ line (1) : error 'equals()' between objects of inconvertible types 'class<derived1>' , 'class<capture of ? extends class>' <br>reports calls .equals() target , argument of incompatible types. while such call might theoretically useful, represents bug. and in runtime if statement fails reason. how can intended behaviour? public class myfactory { public static <t> mybase create(class<t> _c) { return ( _c == derived1.class ) ? createnewderived1() : null; } } // caller myfactory.create(derived1.class); see compare class objects further info. fiy, "real" class obje...
Read more

mysql - Gateway Timeout Error on Insert 70000 record using Hibernate in Java -

-
my problem is: upload 10000 record excel database. excel sheet has 10000 rows , 70 100 column . store value in 6 mapping table using hibernate cascade. call method using ajax method. due inserting large amount of data. return timeout error(502 (proxy error) or 504 (gateway error)). i using aws services. configuration mistake.. please help thanks in advance how might see 502 bad gateway error based on web server, might see different 502 error. these mean same thing, naming conventions differ. here few examples of might see: “502 bad gateway” “http error 502 – bad gateway” “502 service temporarily overloaded” “error 502” “502 proxy error” “http 502” “502 bad gateway nginx” can see in greater detail error entails going web server’s error log file. error / diagnostic information stored in file making valuable resource check when need more details particular error. can locate file in apache going /var/log/apache2/error.log , in nginx going /var/log/nginx/error.log. ...
Read more